Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
InventoryControlDocumentID (FK)(PK) | The reference number that uniquely identifies the InventoryControlDocument. | ID_ICD | Identity | integer | ICDMerchandiseLineItem(DO_LTM_ICD_MR) |
InventoryControlDocumentLineItemID (FK)(PK) | A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. | IC_LTM_ICD | LineNumber | smallint | ICDMerchandiseLineItem(DO_LTM_ICD_MR) |
ItemTraceableUnitID (FK)(PK) | A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item. | ID_ITM_UN_TRC | IdentityUUID | CHAR(32) | ItemTraceableUnit(AS_ITM_TRCBL_UN) |